package jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;

/**
 * 执行关联查询
 */
public class JDBCDemo5 {
	public static void main(String[] args) {
		//查看一年级一班的学生信息
		try(Connection connection = DBUtil.getConnection();){
			Statement statement = connection.createStatement();
			String sql = "select s.name,s.gender,s.age,s.job,c.name,c.floor\n" +
					"from class c \n" +
					"join student s on c.id = s.class_id\n" +
					"where c.name = '1年级1班'";
			ResultSet rs = statement.executeQuery(sql);
			System.out.println("学生姓名--性别--年龄--职位--班级名--楼层");
			while(rs.next()){
				String sName = rs.getString("s.name");
				String sGender = rs.getString("s.gender");
				int sAge = rs.getInt("s.age");
				String sJob = rs.getString("s.job");
				String cName = rs.getString("c.name");
				int cFloor = rs.getInt("c.floor");
				System.out.println(sName+"--"+sGender+"--"+sAge+"--"+sJob+"--"+cName+"--"+cFloor);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}
